Best Relational Database- Oracle Database
I have used this Database for storing and retrieving the data for a web application. As it is a relational database management system and …
Overview
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered.…
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Reviewer Pros & Cons
- In memory feature - very fast. Earlier queries used to run in fetching data used to take time now it is very fast. We can even select which table shou...
- Oracle Database restoration and recovery is complex. RMAN backup recovery has quite a lot of steps and is complex. In other databases, it is very much...
Pricing
N/A
Unavailable
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build…
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
168 people also want pricing
Alternatives Pricing
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database.
What is TeamDesk?
TeamDesk is a low-code development platform for online database creation. Business owners or managers can build a unique web database solution without any programming to facilitate working with data, organize routine work and create an accessible data source for teams.
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.
Oracle Database Video
Oracle's Converged Database
Oracle Database Competitors
- PostgreSQL
- MariaDB Platform
- Microsoft
Oracle Database Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.
PostgreSQL and MariaDB Platform are common alternatives for Oracle Database.
Reviewers rate Support Rating highest, with a score of 10.
The most common users of Oracle Database are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(1189)Attribute Ratings
Reviews
(1-25 of 64)Companies can't remove reviews or game the system. Here's why
June 23, 2022
Money Well Spent!
[Our] Entire organizational data is placed in Oracle 12c. We, as an organization are extremely satisfied with the performance and the exceptional features Oracle provides.
- Fast indexing data.
- Supports clustered environment.
- Various tools to handle the data.
- Materialized views with extremely large datasets.
- Backing up blobs and clobs.
- Inserting huge amounts of data is somewhat slow as compared to IBM DB2
Oracle [Database] is used by [a] couple of departments to maintain Animation assets and for couple of applications in the Animation movie making workflow.
- Oracle's High Availability setup is very durable
- Performance of the database is very good for large databases
- DR setup is very reliable and can be setup easily
- ASM Storage management makes life easy in managing the datafiles
- Licensing cost is very expensive
- Sometimes getting an expert in Oracle support might be a challenge
May 01, 2021
Why and why not to use Oracle12c Database?
We do support our client's Oracle12c databases hosted in two data centers - One in Plano, Texas and One in Cherokee, Oklahoma. We support approx 400 plus DB instances running in different version of Oracle db- Oracle10g, Oracle11g, and Oracle12c. Our client business is in Aviation Industry. This industry demands state-of-art Technology to better serve their customer with the best quality service at affordable cost. This industry demands High Availability and High-Performance system for quick decision making.
- Oracle12c Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. It is one of the oracle finest solution for disaster recovery and data corruption. In this setup - You have one Primary and one or more standby DB in two or more different geographical locations. So, if the database hosted in one location goes down due to planned or unplanned outages, you can easily operate business from remote location database.
- Oracle12c RAC provides Scale-up architecture. Oracle RAC ensures High Availability. In RAC architecture you have at least two or more physical servers with same configuration connected thru interconnect network. So, if one server goes down, you still have database running from the other(surviving) nodes. In this architecture - You can have appropriate on-demand services. You can easily scale up Servers, CPU, Memory.
- Oracle12c has amazing Performance Tuning framework. You can very easily fine-tune databases running on Oracle12c. Some of the great features are Oracle ADDM, AWR report, ASH report, SQL report, SQL Plan Management, Tuning Advisor - SQL Tuning Advisor, SQL Access Advisor.
- Oracle12c has great Back and Recovery solution using Oracle RMAN(Recovery Manager). Without much intervention and work, you can easily restore the database backup whenever and whereever you want.
- Oracle12c provides great security standards that meet fundamental data security requirements - Data Confidentiality, Data Integrity and Data Availability.
- Oracle Label Security, Oracle Data Redaction, Oracle Data Masking and subsetting, Transparent data protection, database storage encryption, Unified Auditing, and Oracle fine-grained audit are some great oracle features.
- In Oracle Data Guard - Oracle standby database is most of the time passive and nothing happening on it other than applying the log. Even in Oracle Active Data Guard configuration - You can not do more than running the business SQL query on the standby. Oracle must come up with solution such that standby database can also be fully utilized as a full operational database.
- Oracle should improve on Oracle internal locking mechanism, latch, and data concurrency. I have seen databases which runs fine with less number of ACTIVE user sessions. When ACTIVE user sessions are increased in the same database - db performance is deteriorated proportionately. If the database kernel has designed correctly, there won't be any db performance issue regardless of any number of user connections/sessions.
- In current time - DB growth is very common, today your db size is 20GB, It may be 500GB at the end of the year, so on and so on. With respect to db size increase, Oracle must improve on RMAN(Recovery Manager) backup tool. The expectation is that faster backup and restore as and when needed. There is always a debate that - Please don't run RMAN backup,data pump export backup, and gather stats job during business peak hours as it will impact DB performance. Oracle database should have designed in such that Administrative jobs like Backup, data pump export and DB gather stats should not have db performance impact anytime, at any cost. Even Oracle claims that Oracle DBRM (Database Resource Manager) is solution to this problem, but, in actual, it doesn't address the problem in much better way.
April 29, 2021
Review
Oracle 12c is used to support the shopping website of the organization, it's very robust, high performing and THE database is scalable to the needs of increasing traffic on the site. It addressed especially the problem with consolidating databases and scaling, much needed performance of apps using Oracle database.
- Multitenant architecture has reduced the DB foot print and maintenance.
- Refreshing test database from production has become affordable and manageable.
- Restoring and recovering tables with Rman has become easy with 12c.
- Like MySQL Oracle also should provide a way to manage both unstructured and structured Data in same DB.
- More free training through OTN (self study videos) about 12c performance and how to adapt to it.
- Plan stability without adapting to use SPM when upgrading to newer versions. SPM has caused problems like taking up too much memory in the DB server when implementing it to overcome the shortcomings of upgrade with optimizer behavior altering the performance. In a way a more adaptable approach would be beneficial for DBAs for upgrade not compromising performance which I think is one of the biggest challenges upgrading .
April 02, 2021
My review of Oracle Database
A lot of our applications are using Oracle Database as their data store.
- High stability and reliability
- A complete set of database features
- Performance is sub-optimal when data size is large.
- Non-trivial effort to setup. We have to build some automation so developers can save some time to set it up on their local machines.
February 28, 2020
Oracle Database for critical workloads that can scale
Oracle Database forms the primary database (with MySQL as secondary) that is used for the whole organization. It is used to store both internal data (accounts payable, employee records, etc) as well as used for customer data and analytics data sets.
- Oracle Database does security and compliance very well out of the box without the need for much configuration.
- It works very well across on-prem and cloud deployments where we want part of the database in-house (due to compliance reasons) while the rest can be in the public cloud.
- It is also very good in scaling to large datasets and performance numbers ( time to run a SQL query) are much better than DB2, Microsoft SQL Server etc.
- Pricing can be improved to make it much more competitive with other RDBMS options in the space
- Best practices documents and deployment scenarios for running Oracle Database on non-Oracle cloud platforms would be helpful (for example Oracle Database on Google Cloud and Microsoft Azure).
- Certainly room for better integrated and automated SQL tuning.
February 18, 2020
Excellent experience using Oracle products over the past 18+ years.
We use Oracle Database for storing relational data for our OLTP/warehouse DBs. We also use it as a high availability solution (Data Guard). It is being used enterprise-wide. It helps to store, retrieve, and run analytics on data. The Dataguard also helps offload the queries from primary and helps with performance.
- Highly performant/reliable and good technical support
- ACID -- Supports ACID transactions
- Non-structured Data -- XML, hard to use
- High Availability -- Real application clusters are available but it is difficult to set up and maintain
December 14, 2019
Oracle did not live up to our expectations
Oracle was chosen as the database to support an older ERP-type application with the actions of the vendor of the app forcing our hand to use Oracle. So it was to replace a different database. The project was to convert not only the data but also tons of code in the form of stored procedures and scripts. The vendor said it shouldn't be hard. Hah!
- Flashback! With Oracle, you can flashback an entire database or just some tables to the state they were in at a certain point in time. Or you can even write a query that uses the data from a point in time. Very valuable for testing and maybe recovering from an error you just discovered you'd made! Of course, there is overhead for this feature and you need to dedicate a lot of disk space for it and you can't go back forever, but there are times where this is so handy and much quicker than restoring a backup (especially an Oracle backup in multi-tenant architecture).
- There are all sorts of features for limiting the resource usage of users.
- Oracle GUI tools for the developer and the DBA are lacking in polish and user-friendliness. Error handling is poor. You need to restart the tool (esp SQL Developer) at least once a day to correct non-sensical results. Enterprise Manager is known to be powerful but hard to learn/hard to use. Instead much is done on the command line which means you need to memorize commands like in the ancient days of MS-DOS. There are many GUI tools that Oracle produces each with a different idea of how user interfaces should be set up. An awful mishmash. They need to learn to write software from the user;'s point of view.
- Oracle support is not helpful. Oracle is the world's most difficult database to use (especially for the DBA) but the support is lacking - not a winning business model. Slow responses. The first line of support usually knew less than I did because I had plumbed the depths of the Internet before calling them. The support folk were usually from India based on their names. The support process asks if you'd rather get help via email or a phone call. I'd usually say phone call but due to the time difference, they rarely would oblige. I hear that there are certain times of day that if you put in your support request then, you are more likely to get US-based help. It was so common to wait forever for help so you'd have to escalate it to the next level. The next level folks were more likely to know something. See the next point re: support.
November 20, 2019
Immensely complicated
The Oracle database is currently used in several places throughout the institute. For starters, it works as our website's back end. We don't store any LOB objects, simply base data types. Similarly, we have developed a handful of custom applications that run on top of Oracle. Each application is a bit unique, but overall the underlying structure isn't too much different from the Website. Lastly, we use Oracle to store one of our largest data provider's information. Currently, this is in the realm of 2 billion rows spread across a small subset of tables.
- The database itself rarely goes down.
- Bringing up new Oracle instances is relatively painless.
- With the help of data pumps, moving data from place to place is a breeze.
- If you pay for their support, while they aren't the speediest, they are incredibly well informed and are an amazing help.
- Immensely complicated. Of all the databases we use, this one has by far the most moving parts.
- It is highly recommended to have a dedicated Oracle DBA on staff if you want your databases healthy. We have no such difficulty with Sybase, SQL Server or SAP IQ.
- While the Support Team is incredibly informative, they are often very slow to respond and are often unwilling to answer questions that don't directly solve the problem at hand.
October 04, 2019
Database 12c offers great new features
Oracle Database 12c is used by multiple departments at our company. It is the backend database for a number of applications that we run, both Oracle provided applications and supported applications. It addresses the performance and daily functions of our business. We use it for a variety of functions from customer-facing to internal apps.
- Oracle 12c offers many new features that are performing well. Online partitioning has been a large benefit that was not offered in past versions.
- From a larger perspective, I think that Oracle 12c Database offers better performance than Microsoft SQL Server does.
- Oracle 12c allows the ability to restore just one table via RMAN and that allows us to save time.
- Oracle 12c has some slight differences from version 12.1 to 12.2 that have forced us to recode or alter DDL to allow the same features to work.
- I wish that RMAN would error out at the beginning instead of the end when there are version discrepancies.
October 02, 2019
Tekvista's Oracle DB 12 c Review
Oracle Database 12 C is used by our entire organization. It is used for our data repository. Oracle 12c has number of features and easily scalable for enterpise requirements. Along with the features, support is provided for integration with different platforms which helps in building applications with different technologies possible.
- Large set of data can be stored & retrieved easily
- Cloud based so can retrieve from anywhere, anytime
- Difficult for beginners to learn
- Not optimized for low performance systems
- License is expensive
I upgraded all Oracle production databases (about 15 production databases) from 11g R2 to 12c R2. The Oracle 12c databases are used university-wide, and are really critical to the university business.
- I believe other users have reviewed the pros already. I am addressing only the Cons of 12c R2.
- SYSAUX tablespace grows rapidly. I didn't need to add space to SYSAUX last a few years in 11g. But after upgrading to 12c R2 12.2.0.1, SYSAUX grows daily, and I have to add space to SYSAUX regularly, about every 2 weeks. I am currently opening an Oracle SR and working with Oracle Support on this issue.
- Some of our small databases only use about 5GB excluding SYSAUX. But SYSAUX uses 5GB alone!
- Almost all universities (if not all) in the USA have been using Banner application. But Banner app users fail to log on 12c Release 2 databases after upgrading to 12c R2 from 11g because of an Oracle Bug related to password-protected profile. I applied an interim bug to work around this issue. However, since Oct 2018, the PSU patching will not work. I must rollback the interim bug, and then patch the PSU, and then apply the interim patch again to resolve the Oracle bug. I asked Oracle to include the interim in the PSU in Oct 2018. But up to PSU Jul 2019, Oracle didn't implement it yet!
September 19, 2019
Oracle Database 12c review
Oracle Database is being used by my organization as the primary database for data storage. We use it with hibernate to be able to develop in Java and use the database in an object-oriented way.
- Reliability.
- Performance.
- Scalability.
- It's hard to set up in different environments.
September 19, 2019
Database 12C in site
It is used to store all student and business data throughout the university.
- Speed
- Security
- Up-time
- Usability
- Ease of use
- Setup
September 18, 2019
Oracle and Visual Studio 2019... no developer tools yet!
Multiple departments use Oracle and different software use connections to multiple databases that are in Oracle. It allows connectivity with all applications and it's useful for all the reporting tools we have. We can keep all our customer data in one central location.
- Oracle allows you to connect to multiple reporting tools.
- Oracle has extensive patches and distributes them in a timely manner when they release them.
- They can handle multiple databases and hold tons of data history.
- It is very reliable and doesn't crash like other products.
- SQL Developer lacks functionality that would be useful, like displaying all records at once when you query
- SQL Developer crashes a lot and it is buggy. We would love to use it more but it is hard to use at times.
- They haven't or don't release Oracle Data tools for Visual Studio 2019. We are almost at the end of the year 2019 and still no data tools yet.
- Connection to .NET is kind of complicated and not very easy as compared to Microsoft SQL Server that allows you to connect easier.
- Oracle, in general, doesn't compare in terms of use with SQL Server. Data takes a little bit longer to get pulled when you create .Net applications.
- Connections have to be opened and closed or else you can end up with multiple connections open. As opposed to SQL Server where it opens the connection and it is closed immediately with very little code.
- Oracle doesn't provide many examples of how Oracle implements and interacts with .NET.
September 18, 2019
Oracle and VSE Corp
The Oracle database is currently what houses our data in relation to our corporate ERP system. The database sits on an Oracle Database 12c appliance for ease of access and use. On the ODA, this Oracle Database 12c is 1 of 5. Also running in parallel are another five that run for production, testing, and development. This database and architecture were selected for performance and security reasons
- Performance - We have several ERP systems all running on various platforms. By far the best performance in terms of consistency being up and available is our Oracle platform. To put into scale, out of all three platforms, since I have been employed, Oracle has not been down once, while the other two have been down multiple times, to the point that my attendance at OOW2019 is focused on migration from other platforms to Oracle.
- Security - The matter of security is huge. One of the biggest points in choosing an Oracle database and appliance over anything else is the security it provides in counter to anything else on the market.
- Training - While there is an enormous amount of training available, there are still gaps in terms of availability for classroom-style learning. I have found it more effective to be in a classroom setting where one is held accountable at that moment in time as opposed to self-paced (pure personal preference).
- Cost - While we love the databases and appliances, the cost of maintaining is becoming an issue when competitors are coming in at such a lower point. Pushing this to a more profits oriented C-level makes justification difficult at times.
September 18, 2019
Oracle Rocks!!!
We are using Oracle Database for all of our critical applications for both OLTP and DW usage. It is used across the organization. It provides us a single platform to store all of our critical data and then extract it to use for analytics. It provides us an efficient OLTP database for managing high traffic processing applications
- Nice SGA management
- Easy to apply profiles on poorly performing SQLs
- One platform for both OLTP and analytics
- Auto SQL tuning
- Better LOB management
- XML Processing
September 18, 2019
Great Performance at a Price Point
Oracle Database 12c is being used across our whole organization. For example, the HR department uses the database to keep track of various details about the employees such as compensation benefits. Our core development team is using it to store all of the user data coming from our commercial web solutions.
- Active Data Guard does a great job of ensuring data protection, disaster recovery, and high availability. These features allow Oracle Database 12c to be a reliable solution.
- OLAP is fairly simple and easy to use allowing users to quickly create analytical graphs and calculations for business intelligence.
- The wide variety of partitioning options allow users with all types of use cases to increase availability/performance and decrease costs of maintaining Oracle Database 12c.
- Licensing and compliance agreements need to be a bit more direct and precise. Many important details are written in the fine print and are easily overlooked.
- There is a lack of first-party documentation for the product. Often times, I see myself referring to third-party sources to find the solutions to my queries.
- Compared to many other database solutions out there, Oracle tends to be a bit expensive. Pricing models should be adjusted according to the competition.
September 18, 2019
The database that you can trust.
The organization uses Oracle Database to store and process day-to-day transactions. The database is used by most areas of the business to perform the end to end business process. We've been using Oracle products for the past 5 years or so and find it reliable.
- The system is stable and helps the business function without interruption.
- Highly scalable, thus provides the expected results when the business needs it.
- Lower maintenance overhead due to its robustness.
- Autonomous capabilities in an on-prem system may help the business achieve higher efficiencies.
September 18, 2019
Oracle Database 12c works for me
The database is being used across the entire organization. It is used to host all of the data for our homegrown software solutions. In addition, it is used to host our data warehouse and integrate the data between all of our enterprise applications. Oracle Database is used along with PL/SQL interfaces and Oracle SOA Suite.
- Oracle Database 12c makes the development of REST Endpoints through the use of ORDS extremely easy, making for faster development
- Oracle Database 12c makes it easy to store and retrieve data as well as integrate different systems and keep data flowing between systems.
- Oracle Database 12c has a very strong PL/SQL interface which makes writing the business logic into the back end of our applications fast and easy.
- Oracle Database 12c has some bugs which sometimes make it difficult to tune queries and improve the performance of our applications.
- Oracle Database 12c has a very robust and complicated interface which makes it powerful but difficult to train new employees on how to use.
- PL/SQL is a proprietary programming language for Oracle Database which makes it difficult to find knowledgeable job candidates fresh out of college.
September 18, 2019
My experience with the new Oracle 12c
Oracle 12c is being used by DIR to create relational databases for transmission of CA workers comp claims. We use it to manage data regarding any occupational illness or injury. This includes doctors, patients, injury, and prescription information. We then run reports on the data to get analytics on various things like opioid usage and the amount of injured employees in California in a given month.
- New bug fixes
- Easy for structure design
- Easy to switch from older Oracle versions
- The current private/public cloud options are very black/white
- Performance was lacking in some cases as wait times increased
- In moving to 12c, there was a lot of workarounds needed for our current system to be fully functional
September 17, 2019
Best Database Option
Oracle Database is currently used for banking data storage. It's very fast and makes it easy to store and manage the data.
- Fast - Data retrieval and manipulation is very quick.
- Simple - The language PL/SQL is easy to work with.
- None that I can think of.
September 17, 2019
Oracle Database Rocks
We use the database for many OLAP and OLTP applications. The database works really great. The error messages could be more informative, however.
- Very robust.
- Works great if initial set-up is done correctly.
- Error messages that are displayed can be improved.
- Need to improve performance tuning.
September 17, 2019
Oracle: It's always a Miracle
It's used across the whole organization, as far as I know. So far it solved all the problems per the traditional relational database (such as complex processing and faster performance), but It's not helping with the cloud. We're thinking about moving to a Cloud-Native database because we're looking for a dynamic database (not as static).
- It's the best one in terms of Relational Database with the support to indexing, maintaining relations between the tables, etc.
- Faster performance in fetching results, especially when running complex queries with multiple tables.
- There's no easy way to Store JSON objects in the DB. We had to do some workarounds.
- We need a little more detailed explanations for the exceptions or errors thrown. For example, if it reaches a session limit while fetching a connection, it's better to throw the count in there that X of X are currently in use, etc.
September 17, 2019
I Like it
We provide consultancy service to a company's different sectors. In my account, we service a company in the financial sector. We provide services such as change and incident management, we work on service requests to provide access and manage users privileges, and troubleshoot performance issues at the query level to avoid impacts on established SLAs.
- Provide edge technology.
- Customer support is sometimes bad and if the ticket is not high priority It could take a lot of time to be attended to.